package com.sz.bi.entity

import org.springframework.data.jpa.repository.JpaSpecificationExecutor
import org.springframework.data.repository.CrudRepository
import org.springframework.stereotype.Repository
import java.sql.Timestamp
import javax.persistence.Column
import javax.persistence.Entity
import javax.persistence.Id
import javax.persistence.Table

@Entity
@Table(name = "T_MBG_BGACTUAL92252432")
data class TMbgBgActual(

        @Id
        @Column(name = "FID")
        val fid: String? = null,

        @Column(name = "FCREATORID")
        val fcreatorid: String? = null,

        @Column(name = "FCREATETIME")
        val fcreatetime: Timestamp? = null,

        @Column(name = "FLASTUPDATEUSERID")
        val flastupdateuserid: String? = null,

        @Column(name = "FLASTUPDATETIME")
        val flastupdatetime: Timestamp? = null,

        @Column(name = "FORGUNITID")
        val forgunitid: String? = null,

        @Column(name = "FFORMULA")
        val fformula: String? = null,

        @Column(name = "FVALUE")
        val fvalue: Long? = 0,

        @Column(name = "F2")
        val f2: String? = null,

        @Column(name = "FBGITEMCOMBINID")
        val fbgitemcombinid: String? = null,

        @Column(name = "FBGPERIODID")
        val fbgperiodid: String? = null,

        @Column(name = "FBGELEMENTID")
        val fbgelementid: String? = null,

        @Column(name = "FCURRENCYID")
        val fcurrencyid: String? = null,

        @Column(name = "FSCENARIO")
        val fscenario: Int? = 0,

        @Column(name = "FVERSION")
        val fversion: Int? = 0,

        @Column(name = "FSTATE")
        val fstate: Int? = 0,

        @Column(name = "FISUPDATE")
        val fisupdate: Int? = 0
)

@Repository
interface TMbgBgActualRepo : CrudRepository<TMbgBgActual, String>, JpaSpecificationExecutor<TMbgBgActual>